Overview of Data Sheet Variables
To ensure that all of the necessary information (for campaign planning, for example) can be entered, Ron and his team have numerous variables (field functions) available for the data sheet layout. The following is a tabular list of variables used that are specific to the Jobs module and that you will encounter in your daily work with job data sheets.

The following table shows an overview of the variable types used that you may encounter on a data sheet. To provide a better overview, they are sorted alphabetically and explained here briefly.
Function |
Description |
---|---|
Action |
This variable represents a button on the data sheet. Clicking on it opens the stored URL. |
Asset Selector |
You can use this to add assets from the Media Pool or locally saved image files (see Asset Selector).
|
Task Manager |
In this area, you can view and edit the tasks assigned to individual workflow steps and post expenses. For all the details, see the chapter LTask Manager. |
Selection field (single or multi-select) |
Here you will find a selection of predefined entries. Both drop-down lists and radio buttons are possible. Selection fields can be linked to custom objects so that, for example, centrally defined boilerplate texts can be selected. |
User |
This function is responsible for searching and selecting users on the data sheet. |
Date selection field and date picker |
Here, you can enter a date in the format DD.MM.YYYYor select one using a date picker. Another option is to use a date picker with an additional time selection.
|
Single-select |
This allows you to select a single stored value. |
Combo box |
A combo box contains a list of elements from which you can choose. It consists of a text field at the top and a drop-down list. Users can either select a stored value from the drop-down list or enter their own value in the text field. |
Multi-select |
This type of field allows you to make a selection from multiple stored values. |
Table |
To enter and display required information in a tabular view, two different table types can be set up on the data sheet. For more information, see the section Tables. |
Text fields (single or multi-line) |
These are fields in which you can enter a text that can consists of one or more lines. The maximum number of characters allowed may be limited. Rules can be stored in advance to ensure that only valid entries are made. |
Reference/Relation |
In extended tables: A Reference/Relation field allows information from other data sheets to be used, e.g. to display product information from the Marketing Data Hub module. As a field on the data sheet: If you select a job from a drop-down list in a field of this type in a workflow step, for example, later assignees can click on a link in the data sheet to open that job or select a job again. |
Reference/Property |
In extended tables: This allows variables from another data sheet (such as Asset Selector) to be displayed in their own table column. In the figure, the reference to the image asset has been added to the product name. |